Create A Field
Type "Trans" in the Field Name box
Press the Tab key
Access accepts the field name, moves your cursor to the Field Type box,
and displays "Text" field properties in the Field Properties window.
Click the down arrow in the Data Type box.
Access displays a list of field types.
Click AutoNumber
Press the Tab key
Access accepts the AutoNumber field type and moves your cursor the
Description box.
Type Transaction Number
Set Primary Key
Click the Primary Key button on the
standard toolbar
The Trans field now becomes the primary key for this table.
Press the Tab key
Access moves your cursor to the second row.
Now you try!